	<table class="bordered" width="770">
        <thead>
            <tr>
                <th>Welcome to Admin Panel!</th>
            </tr>
        </thead>
	</table>
    <table class="bordered" width="770">
		<tr class="home_td">
			<td class="home_td">Total Number of Products</td>
            <td class="home_td1"><?php echo countOfAll("tbl_stocks_available");?></td>
		</tr>
        <tr class="home_td">
			<td class="home_td">Total Number of Stock Entry</td>
            <td class="home_td1"><?php echo countOf("tbl_stocks","type='entry'");?></td>
		</tr>
        <tr>
			<td class="home_td">Tatal Sales Transactions </td>
            <td class="home_td1"><?php echo countOfAll("tbl_sales");?></td>
		</tr>
        <tr>
			<td class="home_td">Total number of Suppliers </td>
            <td class="home_td1"><?php echo countOfAll("tbl_suppliers");?></td>
		</tr>
        <tr>
			<td class="home_td">Total Number of Customers </td>
            <td class="home_td1"><?php echo countOfAll("tbl_customers");?></td>
		</tr>
	</table>
    <table class="bordered" width="770">
        <thead>
            <tr>
                <th>Please Add Stock For These Products..!</th>
            </tr>
        </thead>
	</table>
    <div id="dt_example">
        <table cellpadding="0" cellspacing="0" border="0" class="display" id="example">
            <thead>
                <tr>
                    <th>Product Code</th>
                    <th>Product Name</th>
                    <th>Available</th>
                </tr>
            </thead>
            <tbody>
                <?php
                $sql = "SELECT * FROM tbl_stocks_available ORDER BY qty ASC ";
                $result = mysql_query($sql);
                while ( $row = mysql_fetch_object($result)){
                $qty=$row->qty;
                ?>
                <tr >
                    <?php
                        if($qty <= 5){
                    ?>
                    <td><?php echo $row->pd_code; ?></td>
                    <td><?php echo $row->pd_name; ?></td>
                    <td style="color:#F00; font-weight:bold;"><?php echo $row->qty; ?></td>
        
                </tr>
                <?php 
                       }//end if
                }
                ?>
            </tbody>
        </table>
</div>
